#*********************************************************************
# Description:
# Retrieving data is done by using sasql_query() to execute a SELECT
# statement. The result set can be displayed in HTML format by passing
# it to sasql_result_all().
#
#*********************************************************************

# Connect using the default user ID and password
$conn = sasql_connect ( "UID=DBA;PWD=sql" ) ;
if ( ! $conn ) {
　　echo "sasql_connect failed \n " ;
} else {
　　echo "Connected successfully \n " ;
　　# Execute a SELECT statement
　　$result = sasql_query ( $conn , "SELECT * FROM Customers" ) ;
　　if ( ! $result ) {
　　　　echo "sasql_query failed!" ;
　　} else {
　　　　echo "query completed successfully \n " ;
　　　　# Generate HTML from the result set
　　　　sasql_result_all ( $result ) ;
　　　　sasql_free_result ( $result ) ;
　　}
　　# Close connection
　　sasql_close ( $conn ) ;
}